MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

15 rows where Object Name = 6049

View and edit SQL

Suggested facets: Culture, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Begin Date, Medium, Credit Line

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
68881 1976.390.8 0 1 81749 Costume Institute 8 Visiting dress 6049 Visiting dress French 7         Designer 5   Jacques Doucet French, Paris 1853–1929 Paris   Doucet, Jacques 5483 French 2 1853 1929 ca. 1903 1898 1908 wool, cotton, silk, metallic thread 15743   Gift of Irma A. Bloomingdale, 1976                           Metropolitan Museum of Art, New York, NY 1
69030 1980.145.1a, b 0 1 82085 Costume Institute 8 Visiting dress 6049 Visiting dress British 6                           ca. 1822 1817 1827 silk 15101   Purchase, Irene Lewisohn Bequest, 1980                           Metropolitan Museum of Art, New York, NY 1
70339 1976.60.9a–d 0 1 84277 Costume Institute 8 Visiting dress 6049 Visiting dress American 1                           1865–75 1865 1875 silk 15101   Purchase, Irene Lewisohn Bequest, 1976                           Metropolitan Museum of Art, New York, NY 1
70424 1977.204.2a, b 0 1 84382 Costume Institute 8 Visiting dress 6049 Visiting dress American 1                           1863–65 1863 1865 silk, cotton, glass 16095   Gift of Althea Adams May, 1977                           Metropolitan Museum of Art, New York, NY 1
71035 25.200a, b 0 1 85359 Costume Institute 8 Visiting dress 6049 Visiting dress French 7         Designer 5   Emile Pingat French, active 1860–96   Pingat Emile 5762 French 2 1860 1896 ca. 1872 1867 1877 silk 15101   GIft of Mrs. George D. Cross, 1925                           Metropolitan Museum of Art, New York, NY 1
73810 1979.231.1a, b 0 1 92339 Costume Institute 8 Visiting dress 6049 Visiting dress probably American 40                           1890–93 1890 1893 silk 15101   Gift of Mrs. Howard Ellis Cox, 1979                           Metropolitan Museum of Art, New York, NY 1
79659 1976.208.4a, b 0 1 107055 Costume Institute 8 Visiting dress 6049 Visiting dress French 7                           1888–89 1888 1889 silk, glass, cotton 15694   Gift of Charlotte Church Collins, in memory of my mother, Alice Slocum Church, 1976                           Metropolitan Museum of Art, New York, NY 1
79968 1979.162.1a–c 0 1 107599 Costume Institute 8 Visiting dress 6049 Visiting dress probably French 203                           1886 1886 1886 silk 15101   Gift of Mrs. Elliott M. Sanger, 1979                           Metropolitan Museum of Art, New York, NY 1
79981 1979.93a, b 0 1 107616 Costume Institute 8 Visiting dress 6049 Visiting dress French 7                           1867 1867 1867 silk, wool, cotton 16487   Catharine Breyer Von Bomel Foundation Fund, 1979                           Metropolitan Museum of Art, New York, NY 1
80002 C.I.37.46.32a–f 0 1 107653 Costume Institute 8 Visiting dress 6049 Visiting dress British 6                           ca. 1866 1861 1871 silk 15101   Gift of Miss Irene Lewisohn, 1937                           Metropolitan Museum of Art, New York, NY 1
80276 C.I.41.32.1 0 1 108082 Costume Institute 8 Visiting dress 6049 Visiting dress American 1                           ca. 1830 1825 1835 cotton 3340   Gift of Miss Mildred Natwick, 1941                           Metropolitan Museum of Art, New York, NY 1
86007 1976.60.2a, b 0 1 121331 Costume Institute 8 Visiting dress 6049 Visiting dress American 1                           1820–23 1820 1823 silk 15101   Purchase, Irene Lewisohn Bequest, 1976                           Metropolitan Museum of Art, New York, NY 1
92956 2009.300.630 0 1 159182 Costume Institute 8 Visiting dress 6049 Visiting dress American 1                           1845–50 1845 1850 silk 15101   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Annie M. Colson, 1929                           Metropolitan Museum of Art, New York, NY 1
93247 2009.300.892a, b 0 1 159473 Costume Institute 8 Visiting dress 6049 Visiting dress French 7         Designer 5   Jacques Doucet French, Paris 1853–1929 Paris   Doucet, Jacques 5483 French 2 1853 1929 1900–1905 1900 1905 silk 15101   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Robert G. Olmsted, 1965                           Metropolitan Museum of Art, New York, NY 1
96886 2009.300.7137a, b 0 1 174265 Costume Institute 8 Visiting dress 6049 Visiting dress American 1                           ca. 1875 1868 1872 Silk 165   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. G. H. Marchant, 1961                           Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 125.945ms · Data license: CC0 · Data source: metmuseum/openaccess